class MembersPotentialCache < ActiveRecord::Migration
  def self.up
    add_column :members, :stored_potential_service_hours, :float, :default => 0
    add_column :members, :stored_potential_fellowships, :integer, :default => 0
    add_column :members, :stored_potential_leaderships, :integer, :default => 0
    add_column :members, :stored_potential_fundraisers, :integer, :default => 0
    add_column :members, :stored_potential_office_hours, :float, :default => 0
    add_column :members, :stored_potential_ceremonies, :integer, :default => 0
    add_column :members, :stored_potential_dues, :integer, :default => 0
    add_column :members, :stored_potential_active_meetings, :integer, :default => 0
    add_column :members, :stored_potential_committees, :integer, :default => 0
    add_column :members, :stored_potential_pledge_reqs, :integer, :default => 0
    add_column :members, :stored_potential_flex_points, :float, :default => 0

    #add_index :members, :id
    #add_index :events, :id
    #add_index :attendance_records, :event_id

  end

  def self.down
    remove_column :members, :stored_potential_service_hours
    remove_column :members, :stored_potential_fellowships
    remove_column :members, :stored_potential_leaderships
    remove_column :members, :stored_potential_fundraisers
    remove_column :members, :stored_potential_office_hours
    remove_column :members, :stored_potential_ceremonies
    remove_column :members, :stored_potential_dues
    remove_column :members, :stored_potential_active_meetings
    remove_column :members, :stored_potential_committees
    remove_column :members, :stored_potential_pledge_reqs
    remove_column :members, :stored_potential_flex_points

    #remove_index :members, :id
    #remove_index :events, :id
    #remove_index :attendance_records, :event_id

  end
end
